MLOGIC:  Beginning compilation of FCF_IEM_FB_PARTY using the autocall file
C:\SAS\Config\Lev1\Applications\SASFinancialCrimesFoundation6.1\custom\source\fcf_iem_fb_party.sas.
WARNING: The quoted string currently being processed has become more than 262 bytes long.  You might have unbalanced quotation marks.
WARNING: Extraneous text on %MEND statement ignored for macro definition FCF_IEM_FB_PARTY.
ERROR: The macro FCF_IEM_FB_PARTY contains at least one %GOTO statement, but no valid labels were defined.  The macro will not be compiled.
ERROR: A dummy macro will be compiled.

FSC_PARTY_DIM.MATCH_CODE_ORGANIZATION' 

FSC_PARTY_DIM.EMPLOYEE_NUMBER' 

proc sql;
  create view work.new_pty_updates_w_info as
  select
    new_pty_updates.X_SASFCS_PTY_KEY as PARTY_KEY,
    FSC_PARTY_DIM.SEGMENT_ID,
    FSC_PARTY_DIM.PARTY_NUMBER,
    FSC_PARTY_DIM.PARTY_TYPE_DESC,
    FSC_PARTY_DIM.PARTY_TAX_ID,
    FSC_PARTY_DIM.PARTY_TAX_ID_TYPE_CODE,
    FSC_PARTY_DIM.PARTY_IDENTIFICATION_ID,
    FSC_PARTY_DIM.PARTY_IDENTIFICATION_TYPE_DESC,
    FSC_PARTY_DIM.PARTY_ID_STATE_CODE,
    FSC_PARTY_DIM.PARTY_DATE_OF_BIRTH,
    FSC_PARTY_DIM.PARTY_FIRST_NAME,
    FSC_PARTY_DIM.PARTY_LAST_NAME,
    FSC_PARTY_DIM.PARTY_MIDDLE_NAME,
    FSC_PARTY_DIM.PARTY_NAME,
    FSC_PARTY_DIM.DOING_BUSINESS_AS_NAME,
    FSC_PARTY_DIM.PARTY_STATUS_DESC,
    FSC_PARTY_DIM.ULTIMATE_PARENT_NAME,
    FSC_PARTY_DIM.MATCH_CODE_ORGANIZATION',
    FSC_PARTY_DIM.MATCH_CODE_INDIVIDUAL,
    FSC_PARTY_DIM.MATCH_CODE_STREET_ADDRESS,
    FSC_PARTY_DIM.MATCH_CODE_MAILING_ADDRESS,
    FSC_PARTY_DIM.MATCH_CODE_STREET_ADDR_LINES,
    FSC_PARTY_DIM.MATCH_CODE_STREET_CITY,
    FSC_PARTY_DIM.MATCH_CODE_STREET_STATE,
    FSC_PARTY_DIM.MATCH_CODE_STREET_COUNTRY,
    FSC_PARTY_DIM.MATCH_CODE_MAILING_ADDR_LINES,
    FSC_PARTY_DIM.MATCH_CODE_MAILING_CITY,
    FSC_PARTY_DIM.MATCH_CODE_MAILING_STATE,
    FSC_PARTY_DIM.MATCH_CODE_MAILING_COUNTRY,
    FSC_PARTY_DIM.STREET_ADDRESS_1,
    FSC_PARTY_DIM.STREET_ADDRESS_2,
    FSC_PARTY_DIM.STREET_CITY_NAME,
    FSC_PARTY_DIM.STREET_STATE_CODE,
    FSC_PARTY_DIM.STREET_STATE_NAME,
    FSC_PARTY_DIM.STREET_POSTAL_CODE,
    FSC_PARTY_DIM.STREET_COUNTRY_CODE,
    FSC_PARTY_DIM.STREET_COUNTRY_NAME,
    FSC_PARTY_DIM.MAILING_ADDRESS_1,
    FSC_PARTY_DIM.MAILING_ADDRESS_2,
    FSC_PARTY_DIM.MAILING_CITY_NAME,
    FSC_PARTY_DIM.MAILING_STATE_CODE,
    FSC_PARTY_DIM.MAILING_STATE_NAME,
    FSC_PARTY_DIM.MAILING_POSTAL_CODE,
    FSC_PARTY_DIM.MAILING_COUNTRY_CODE,
    FSC_PARTY_DIM.MAILING_COUNTRY_NAME,
    FSC_PARTY_DIM.RESIDENCE_COUNTRY_CODE,
    FSC_PARTY_DIM.RESIDENCE_COUNTRY_NAME,
    FSC_PARTY_DIM.CITIZENSHIP_COUNTRY_CODE,
    FSC_PARTY_DIM.CITIZENSHIP_COUNTRY_NAME,
    FSC_PARTY_DIM.ORG_COUNTRY_OF_BUSINESS_CODE,
    FSC_PARTY_DIM.ORG_COUNTRY_OF_BUSINESS_NAME,
    FSC_PARTY_DIM.EMPLOYEE_IND,
    FSC_PARTY_DIM.EMPLOYEE_NUMBER',
    FSC_PARTY_DIM.EMPLOYER_NAME,
    FSC_PARTY_DIM.EMPLOYER_PHONE_NUMBER,
    FSC_PARTY_DIM.EMAIL_ADDRESS,
    FSC_PARTY_DIM.OCCUPATION_DESC,
    FSC_PARTY_DIM.INDUSTRY_CODE,
    FSC_PARTY_DIM.INDUSTRY_DESC,
    FSC_PARTY_DIM.PHONE_NUMBER_1,
    FSC_PARTY_DIM.PHONE_NUMBER_2,
    FSC_PARTY_DIM.PHONE_NUMBER_3,
    FSC_PARTY_DIM.ANNUAL_INCOME_AMOUNT,
    FSC_PARTY_DIM.NET_WORTH_AMOUNT,
    FSC_PARTY_DIM.MARITAL_STATUS_DESC,
    FSC_PARTY_DIM.LAST_CONTACT_DATE,
    FSC_PARTY_DIM.POLITICALLY_EXPOSED_PERSON_IND,
    FSC_PARTY_DIM.NON_PROFIT_ORG_IND,
    FSC_PARTY_DIM.CUSTOMER_SINCE_DATE,
    FSC_PARTY_DIM.LAST_SUSP_ACTV_RPT_DATE,
    FSC_PARTY_DIM.LAST_CASH_TRANS_RPT_DATE,
    FSC_PARTY_DIM.LAST_RISK_ASSESSMENT_DATE,
    new_pty_updates.X_SASFCS_RSK_CLSSF as RISK_CLASSIFICATION,
    FSC_PARTY_DIM.CHANGE_BEGIN_DATE,
    FSC_PARTY_DIM.CHANGE_END_DATE,
    FSC_PARTY_DIM.CHANGE_CURRENT_IND,
    FSC_PARTY_DIM.EXTERNAL_PARTY_IND,
    FSC_PARTY_DIM.LEGAL_ENTITY_TYPE,
    FSC_PARTY_DIM.MONEY_ORDERS_IND,
    FSC_PARTY_DIM.TRAVELERS_CHEQUES_IND,
    FSC_PARTY_DIM.PREPAID_CARDS_IND,
    FSC_PARTY_DIM.MSB_IND,
    FSC_PARTY_DIM.MONEY_TRANSMITTER_IND,
    FSC_PARTY_DIM.CURRENCY_EXCHANGE_IND,
    FSC_PARTY_DIM.CHECK_CASHER_IND,
    FSC_PARTY_DIM.INTERNET_GAMBLING_IND,
    FSC_PARTY_DIM.TRUST_ACCOUNT_IND,
    FSC_PARTY_DIM.FOREIGN_CONSULATE_EMBASSY_IND,
    FSC_PARTY_DIM.ISSUES_BEARER_SHARES_IND,
    FSC_PARTY_DIM.NEGATIVE_NEWS_IND
from work.new_pty_updates left join
     &db_core_libname..FSC_PARTY_DIM
     on( new_pty_updates.X_SASFCS_PTY_KEY = FSC_PARTY_DIM.PARTY_KEY)
;
quit;